2015-04-27- 18783 - Service Request - INV100 - Add Japan Sales Org #InventoryManagement
SPECIFICATIONS
18783 - INV100 - Add Japan Sales Org
Problem Summary
Need to include the Japan Sales Org(3200) in the Stock ATP Inventory(INV100) Report.
Admin Info
Purpose
|
Need to include the Japan sales org (3200) in The Stock ATP Inventory (INV100) Report.
|
Requested by
|
Christine Di Vicenzo
|
Issue Date
|
04-27-2015
|
Resolved by
|
Uday Kumar P
|
Resolved Date
|
04-28-2015
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Mark G on 04/27/2015:
I have assigned you Service Request 18783 with the requirement to add the Japan Sales Org 3200 to the INV100 - ATP Stock Inventory report. Please let me know who on your team will be taking on the work and when you feel this can be completed by.
Email from Mark G on 04/28/2015:
When work on this report begins i would like to be provided with a list of Sales Org's that the function in ECC is pulling.
We may need to add more than Japan if others are missing.
Email from Mark G on 04/28/2015
Mark H. had indicated that there was an ECC function that was preventing the additional sales orgs from being pulled into this report. Could you please check how the 'ZSDATP' table is being populated and identify any filters that may be causing 3200's being excluded.
Email from Mark G on 04/29/2015
We will need to have ZRSD_WEEKLY_ATP_UPDATE function updated to allow all applicable sales orgs into this report.
In addition to the Sales Orgs currently accounted for please add the below:
Key Text
1100 US Apparel Sales
1500 Mexico Sales
1700 Latin America Sales
2100 German Sales
2200 EMEA Web Sales
3100 Korea Sales
3200 Japan Sales
4000 Australia Sales
4100 New Zealand Sales
5000 5th & Ocean Sales
7400 Blue Label Sales
Email from Daniel Brennan on 04/29/2015:
I will come up with the mapping of sales organizations to plants. However,
I'd like to understand more about how this program is executed. Is there a
batch job that runs the program and variants?
Email from Daniel Brennan on 04/30/2015:
I agree, this deserves a deeper discussion. I'm happy to chat whenever it makes sense.
Since I already put it together, I believe the following would be the plant mapping:
Sales Org
|
Plant
|
1000
|
0110
|
0116
|
0117
|
1416
|
1410
|
1420
|
1200
|
0210
|
1500
|
0280
|
1700
|
0110
|
0116
|
0117
|
1416
|
1410
|
1420
|
2000
|
0320
|
0325
|
2100
|
0320
|
2200
|
0325
|
3000
|
0510
|
3100
|
0585
|
4000
|
0550
|
4100
|
0550
|
5000
|
1410
|
1420
|
1416
|
Solution Analysis and Recommendations
1. INV100 is based on two tables 'ZSDATP' and 'MEAN' from NEP.
2. There is no data for Japan Sales Org 3200 in 'ZSDATP ' table and so the report is not having any data.
3. This table holds data for only Sales Orgs 1000, 1200, 2000 and 3000.
4. There are no active restrictions on Sales Org at report level.
5. Did detailed analysis & debugging of ABAP program ‘ZRSD_WEEKLY_ATP_UPDATE’ which updates the ZSDATP table in NEP.
6. After replicating an example variant in NED300, here is the summary of the logic implemented by this program:
a.Considered an example variant for Sales Org 4100, Distribution channel 10, Division 00, Plant 550, Season STK and Sales doc type ZOR, for the program.
b. Fetched 9 Materials from MVKE table based on Sales Org 4100 and Distribution channel 10.
c. Filtered out Material 10000218 based on Season STK and ignoring other seasons.
d. Fetched the MRP group DMTS for Material 10000218 and Plant 550 from MARC table.
e. Used BAPI Function module '/AFS/BAPI_MAT_AVAILABILITY' to get the ATP stock for 23 grids of Material 10000218, Plant 550, Sales Org 4100, Distribution channel 10, Division 00 and caller application V.
f. Logic splits the ATP stock for first 6 schedule line date buckets.
g. Logic considers the bucket where ATP stock exists and deletes rest of buckets. For Material 10000218, only the following 4 grids have the ATP stock:
Material 10000218 Grid 638 - 951,
Material 10000218 Grid 700 - 81,
Material 10000218 Grid 712 - 8,
Material 10000218 Grid 758 – 90.
h. Logic updates the ATP stock wherever it exists else updates 0 for all 23 grids of the Material 10000218.
i. Based on current week fetches the first day of last week and adds 7 to get first day of current week. For next 7 weeks it is considering the first day of that week to copy the same ATP stock.
j. Updates data to ZSDATP table with all the above entries. For 23 grids * 7 weeks - 161 entries in ZSDATP table for Material 10000218.
Resolution
If data exists in 'ZSDATP' for Japan Sales Org 3200, then it will show the data in the report.
Did not implement the solution as the NEC did not approve the further work on this ticket.
Release Information
None